'use strict';

module.exports = app => {
    const {
        STRING,
        INTEGER
    } = app.Sequelize;
    const system_query = app.model.define('system_query',{
        id:{
            type:INTEGER,
            primaryKey:true,
            autoIncrement:true,
            allowNull:false,
            comment:"千分制查询ID"
        },
        class_name:{
            type:STRING,
            defaultValue:null,
            comment:"班级名字"
        },
        project:{
            type:STRING,
            defaultValue:null,
            comment:"项目"
        },
        name:{
            type:STRING,
            defaultValue:null,
            comment:"名字"
        },
        grades:{
            type:INTEGER,
            defaultValue:null,
            comment:"分数"
        },
        details:{
            type:STRING,
            defaultValue:null,
            comment:"详情项"
        },
        student_number:{
            type:INTEGER,
            allowNull:false,
            unique: true,
            comment:"学号"
        }
    })
    system_query.associate = function () {
        
    }
}